Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY04915
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Email History
Physical Name: SY04915
Technical Name: syEmailHistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Email History'].USERID AS 'Email History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY04915 AS ['Email History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Email History'].USERID = ['Users Master'].USERID2 MODULE1 Module Integer DDL 0 3 DOCTYPE Document Type Integer DDL_Document_Type 0 4 DOCNUMBR Document Number String STR20_Document_Number 20 5 DATE1 Date Date DT6 6 6 TIME1 Time Time TM6 6 7 EmailMessageFrom Email Message From String STR255 255 8 EmailSubject Email Subject String STR255 255 9 Master_ID Master ID String STR30_LBAU 30 10 DICTRYID Dictionary ID Integer DDL_Dictionary 0 11 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 12 EmailFromAddress Email From Address String STR255 255 13 EmailMessageID Email Message ID String STR25_LBAU 25 14 DOCDATE Document Date Date DT 8 15 EmailReplyToAddress Email Reply To Address Text TX32000 32000 16 EmailToAddress Email To Address Text TX32000 32000 17 EmailCcAddress Email Cc Address Text TX32000 32000 18 EmailBccAddress Email Bcc Address Text TX32000 32000 19 EmailBody Email Body Text TX32000 32000